SQL queries

This section is only valid for reports using ODBC data sources. Seagate Crystal Reports automatically generates an SQL query when you design a report based on one or more ODBC data source. This query is sent to the ODBC data source(s) as an instruction to gather the data needed by the report.

To edit an SQL query

1. On the Database menu, click Show SQL Query.
   The Show SQL Query dialog box appears.

   

2. Click anywhere inside the text area to begin making changes.
3. Use the ANSI SQL language to fine-tune the SQL query.

   Note:    You cannot change the SELECT clause of the SQL statement.

   You can cut, copy, or paste any part of the query to or from the Clipboard if needed.For more information, see The SQL language.

4. Click OK when finished.